Pandas Profiling Report

Dataset statistics

Number of variables	44
Number of observations	1312
Missing cells	2970
Missing cells (%)	5.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	451.1 KiB
Average record size in memory	352.1 B

Variable types

CAT	30
NUM	14

Reproduction

Analysis started	2020-08-12 16:51:20.003523
Analysis finished	2020-08-12 16:52:10.147908
Duration	50.14 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`Owner` has a high cardinality: 305 distinct values	High cardinality
`Farm.Name` has a high cardinality: 550 distinct values	High cardinality
`Mill` has a high cardinality: 441 distinct values	High cardinality
`ICO.Number` has a high cardinality: 842 distinct values	High cardinality
`Company` has a high cardinality: 270 distinct values	High cardinality
`Altitude` has a high cardinality: 384 distinct values	High cardinality
`Region` has a high cardinality: 338 distinct values	High cardinality
`Producer` has a high cardinality: 663 distinct values	High cardinality
`Number.of.Bags` has a high cardinality: 131 distinct values	High cardinality
`Bag.Weight` has a high cardinality: 57 distinct values	High cardinality
`Grading.Date` has a high cardinality: 556 distinct values	High cardinality
`Owner.1` has a high cardinality: 308 distinct values	High cardinality
`Total.Cup.Points` has a high cardinality: 179 distinct values	High cardinality
`Expiration` has a high cardinality: 554 distinct values	High cardinality
`altitude_high_meters` is highly correlated with `altitude_low_meters` and 1 other fields	High correlation
`altitude_low_meters` is highly correlated with `altitude_high_meters` and 1 other fields	High correlation
`altitude_mean_meters` is highly correlated with `altitude_low_meters` and 1 other fields	High correlation
`Country.of.Origin` is highly correlated with `Species`	High correlation
`Species` is highly correlated with `Country.of.Origin` and 9 other fields	High correlation
`Bag.Weight` is highly correlated with `Species`	High correlation
`In.Country.Partner` is highly correlated with `Species` and 3 other fields	High correlation
`Harvest.Year` is highly correlated with `Species`	High correlation
`Variety` is highly correlated with `Species`	High correlation
`Processing.Method` is highly correlated with `Species`	High correlation
`Cupper.Points` is highly correlated with `Species`	High correlation
`Moisture` is highly correlated with `Species`	High correlation
`Category.One.Defects` is highly correlated with `Species`	High correlation
`Quakers` is highly correlated with `Species`	High correlation
`Certification.Body` is highly correlated with `In.Country.Partner` and 2 other fields	High correlation
`Certification.Address` is highly correlated with `In.Country.Partner` and 2 other fields	High correlation
`Certification.Contact` is highly correlated with `In.Country.Partner` and 2 other fields	High correlation
`Farm.Name` has 356 (27.1%) missing values	Missing
`Mill` has 310 (23.6%) missing values	Missing
`ICO.Number` has 147 (11.2%) missing values	Missing
`Company` has 210 (16.0%) missing values	Missing
`Altitude` has 223 (17.0%) missing values	Missing
`Region` has 58 (4.4%) missing values	Missing
`Producer` has 231 (17.6%) missing values	Missing
`Harvest.Year` has 49 (3.7%) missing values	Missing
`Variety` has 205 (15.6%) missing values	Missing
`Processing.Method` has 156 (11.9%) missing values	Missing
`Color` has 220 (16.8%) missing values	Missing
`altitude_low_meters` has 231 (17.6%) missing values	Missing
`altitude_high_meters` has 231 (17.6%) missing values	Missing
`altitude_mean_meters` has 231 (17.6%) missing values	Missing
`Acidity` is highly skewed (γ1 = 33.94016411)	Skewed
`altitude_low_meters` is highly skewed (γ1 = 20.07018989)	Skewed
`altitude_high_meters` is highly skewed (γ1 = 20.05804142)	Skewed
`altitude_mean_meters` is highly skewed (γ1 = 20.06752535)	Skewed
`df_index` has unique values	Unique
`ID` has unique values	Unique
`Category.Two.Defects` has 359 (27.4%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	1312
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	657.0274390243902
Minimum	0
Maximum	1318
Zeros	1
Zeros (%)	0.1%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	65.55
Q1	327.75
median	655.5
Q3	986.25
95-th percentile	1252.45
Maximum	1318
Range	1318
Interquartile range (IQR)	658.5

Descriptive statistics

Standard deviation	380.9259134
Coefficient of variation (CV)	0.5797716971
Kurtosis	-1.196408551
Mean	657.027439
Median Absolute Deviation (MAD)	329.5
Skewness	0.01015246627
Sum	862020
Variance	145104.5515

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1318	1	0.1%
430	1	0.1%
432	1	0.1%
433	1	0.1%
434	1	0.1%
435	1	0.1%
436	1	0.1%
437	1	0.1%
438	1	0.1%
439	1	0.1%
Other values (1302)	1302	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%

Value	Count	Frequency (%)
1318	1	0.1%
1317	1	0.1%
1316	1	0.1%
1315	1	0.1%
1314	1	0.1%

ID
Categorical

UNIQUE

Distinct count	1312
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	10.2 KiB

1192	1
157	1
1124	1
1284	1
1210	1
Other values (1307)	1307

Common Values
Length

Value	Count	Frequency (%)
1192	1	0.1%
157	1	0.1%
1124	1	0.1%
1284	1	0.1%
1210	1	0.1%
865	1	0.1%
241	1	0.1%
807	1	0.1%
545	1	0.1%
1151	1	0.1%
Other values (1302)	1302	99.2%

Length

Max length	10
Median length	3
Mean length	3.160823171
Min length	1

Species
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	10.2 KiB

Arabica	1311
unex guatemala, s.a.	1

Common Values
Length

Value	Count	Frequency (%)
Arabica	1311	99.9%
unex guatemala, s.a.	1	0.1%

Length

Max length	20
Median length	7
Mean length	7.009908537
Min length	7

Owner
Categorical

HIGH CARDINALITY

Distinct count	305
Unique (%)	23.4%
Missing	8
Missing (%)	0.6%
Memory size	10.2 KiB

juan luis alvarado romero	155
racafe & cia s.c.a	60
exportadora de cafe condor s.a	54
kona pacific farmers cooperative	52
ipanema coffees	50
Other values (300)	933

Common Values
Length

Value	Count	Frequency (%)
juan luis alvarado romero	155	11.8%
racafe & cia s.c.a	60	4.6%
exportadora de cafe condor s.a	54	4.1%
kona pacific farmers cooperative	52	4.0%
ipanema coffees	50	3.8%
cqi taiwan icp cqi??????	47	3.6%
lin, che-hao krude ???	30	2.3%
nucoffee	29	2.2%
carcafe ltda ci	27	2.1%
the coffee source inc.	23	1.8%
Other values (295)	777	59.2%

Length

Max length	50
Median length	22
Mean length	21.26676829
Min length	3

Country.of.Origin
Categorical

HIGH CORRELATION

Distinct count	37
Unique (%)	2.8%
Missing	1
Missing (%)	0.1%
Memory size	10.2 KiB

Mexico	236
Colombia	183
Guatemala	181
Brazil	132
Taiwan	75
Other values (32)	504

Common Values
Length

Value	Count	Frequency (%)
Mexico	236	18.0%
Colombia	183	13.9%
Guatemala	181	13.8%
Brazil	132	10.1%
Taiwan	75	5.7%
United States (Hawaii)	73	5.6%
Honduras	53	4.0%
Costa Rica	51	3.9%
Ethiopia	44	3.4%
Tanzania, United Republic Of	40	3.0%
Other values (27)	243	18.5%

Length

Max length	28
Median length	8
Mean length	8.887195122
Min length	3

Farm.Name
Categorical

HIGH CARDINALITY
MISSING

Distinct count	550
Unique (%)	57.5%
Missing	356
Missing (%)	27.1%
Memory size	10.2 KiB

various	47
rio verde	23
several	20
finca medina	15
fazenda capoeirnha	13
Other values (545)	838

Common Values
Length

Value	Count	Frequency (%)
various	47	3.6%
rio verde	23	1.8%
several	20	1.5%
finca medina	15	1.1%
fazenda capoeirnha	13	1.0%
doi tung development project	13	1.0%
los hicaques	11	0.8%
conquista / morito	11	0.8%
capoeirinha	10	0.8%
el papaturro	9	0.7%
Other values (540)	784	59.8%
(Missing)	356	27.1%

Length

Max length	73
Median length	10
Mean length	11.97179878
Min length	1

Mill
Categorical

HIGH CARDINALITY
MISSING

Distinct count	441
Unique (%)	44.0%
Missing	310
Missing (%)	23.6%
Memory size	10.2 KiB

beneficio ixchel	90
dry mill	39
trilladora boananza	38
ipanema coffees	16
neiva	15
Other values (436)	804

Common Values
Length

Value	Count	Frequency (%)
beneficio ixchel	90	6.9%
dry mill	39	3.0%
trilladora boananza	38	2.9%
ipanema coffees	16	1.2%
neiva	15	1.1%
bachue	14	1.1%
beneficio siembras vision (154)	12	0.9%
trilladora bonanza - armenia quindioa	12	0.9%
cigrah s.a de c.v.	12	0.9%
cadexsa	12	0.9%
Other values (431)	742	56.6%
(Missing)	310	23.6%

Length

Max length	77
Median length	15
Mean length	15.34679878
Min length	1

ICO.Number
Categorical

HIGH CARDINALITY
MISSING

Distinct count	842
Unique (%)	72.3%
Missing	147
Missing (%)	11.2%
Memory size	10.2 KiB

0	67
Taiwan	31
2222	11
-	9
Taiwan??	7
Other values (837)	1040

Common Values
Length

Value	Count	Frequency (%)
0	67	5.1%
Taiwan	31	2.4%
2222	11	0.8%
-	9	0.7%
Taiwan??	7	0.5%
002/4177/0150	7	0.5%
002/1660/0105	7	0.5%
1	6	0.5%
unknown	6	0.5%
002/1660/0080	6	0.5%
Other values (832)	1008	76.8%
(Missing)	147	11.2%

Length

Max length	40
Median length	9
Mean length	8.362804878
Min length	1

Company
Categorical

HIGH CARDINALITY
MISSING

Distinct count	270
Unique (%)	24.5%
Missing	210
Missing (%)	16.0%
Memory size	10.2 KiB

unex guatemala, s.a.	85
ipanema coffees	50
racafe & cia s.c.a	40
exportadora de cafe condor s.a	40
kona pacific farmers cooperative	40
Other values (265)	847

Common Values
Length

Value	Count	Frequency (%)
unex guatemala, s.a.	85	6.5%
ipanema coffees	50	3.8%
racafe & cia s.c.a	40	3.0%
exportadora de cafe condor s.a	40	3.0%
kona pacific farmers cooperative	40	3.0%
carcafe ltda	25	1.9%
blossom valley????	25	1.9%
nucoffee	24	1.8%
????	20	1.5%
taiwan coffee laboratory	20	1.5%
Other values (260)	733	55.9%
(Missing)	210	16.0%

Length

Max length	80
Median length	18
Mean length	18.35746951
Min length	3

Altitude
Categorical

HIGH CARDINALITY
MISSING

Distinct count	384
Unique (%)	35.3%
Missing	223
Missing (%)	17.0%
Memory size	10.2 KiB

1100	43
1200	41
1300	32
1400	32
4300	31
Other values (379)	910

Common Values
Length

Value	Count	Frequency (%)
1100	43	3.3%
1200	41	3.1%
1300	32	2.4%
1400	32	2.4%
4300	31	2.4%
1500	30	2.3%
1250	30	2.3%
1700	28	2.1%
1550	24	1.8%
1600	22	1.7%
Other values (374)	776	59.1%
(Missing)	223	17.0%

Length

Max length	41
Median length	4
Mean length	5.825457317
Min length	1

Region
Categorical

HIGH CARDINALITY
MISSING

Distinct count	338
Unique (%)	27.0%
Missing	58
Missing (%)	4.4%
Memory size	10.2 KiB

huila	112
oriente	79
south of minas	68
kona	66
veracruz	35
Other values (333)	894

Common Values
Length

Value	Count	Frequency (%)
huila	112	8.5%
oriente	79	6.0%
south of minas	68	5.2%
kona	66	5.0%
veracruz	35	2.7%
tarrazu	19	1.4%
comayagua	17	1.3%
san marcos	16	1.2%
huehuetenango	16	1.2%
marcala	15	1.1%
Other values (328)	811	61.8%
(Missing)	58	4.4%

Length

Max length	76
Median length	8
Mean length	10.52591463
Min length	2

Producer
Categorical

HIGH CARDINALITY
MISSING

Distinct count	663
Unique (%)	61.3%
Missing	231
Missing (%)	17.6%
Memory size	10.2 KiB

La Plata	30
Ipanema AgrÃcola SA	22
Doi Tung Development Project	17
???	14
VARIOS	12
Other values (658)	986

Common Values
Length

Value	Count	Frequency (%)
La Plata	30	2.3%
Ipanema AgrÃcola SA	22	1.7%
Doi Tung Development Project	17	1.3%
???	14	1.1%
VARIOS	12	0.9%
Ipanema Agricola	12	0.9%
Ipanema Agricola S.A	11	0.8%
ROBERTO MONTERROSO	10	0.8%
AMILCAR LAPOLA	9	0.7%
LA PLATA	9	0.7%
Other values (653)	935	71.3%
(Missing)	231	17.6%

Length

Max length	104
Median length	17
Mean length	17.52591463
Min length	1

Number.of.Bags
Categorical

HIGH CARDINALITY

Distinct count	131
Unique (%)	10.0%
Missing	1
Missing (%)	0.1%
Memory size	10.2 KiB

250	240
275	176
10	108
1	87
300	71
Other values (126)	629

Common Values
Length

Value	Count	Frequency (%)
250	240	18.3%
275	176	13.4%
10	108	8.2%
1	87	6.6%
300	71	5.4%
320	70	5.3%
50	42	3.2%
100	37	2.8%
20	35	2.7%
2	29	2.2%
Other values (121)	416	31.7%

Length

Max length	12
Median length	3
Mean length	2.432926829
Min length	1

Bag.Weight
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	57
Unique (%)	4.3%
Missing	1
Missing (%)	0.1%
Memory size	10.2 KiB

1 kg	326
60 kg	242
69 kg	200
70 kg	156
2 kg	114
Other values (52)	273

Common Values
Length

Value	Count	Frequency (%)
1 kg	326	24.8%
60 kg	242	18.4%
69 kg	200	15.2%
70 kg	156	11.9%
2 kg	114	8.7%
100 lbs	59	4.5%
30 kg	29	2.2%
5 lbs	21	1.6%
6	19	1.4%
20 kg	14	1.1%
Other values (47)	131	10.0%

Length

Max length	8
Median length	5
Mean length	4.701981707
Min length	1

In.Country.Partner
Categorical

HIGH CORRELATION

Distinct count	27
Unique (%)	2.1%
Missing	1
Missing (%)	0.1%
Memory size	10.2 KiB

Specialty Coffee Association	295
AMECAFE	205
AlmacafÃ©	178
Asociacion Nacional Del CafÃ©	154
Brazil Specialty Coffee Association	67
Other values (22)	412

Common Values
Length

Value	Count	Frequency (%)
Specialty Coffee Association	295	22.5%
AMECAFE	205	15.6%
AlmacafÃ©	178	13.6%
Asociacion Nacional Del CafÃ©	154	11.7%
Brazil Specialty Coffee Association	67	5.1%
Instituto HondureÃ±o del CafÃ©	60	4.6%
Blossom Valley International	59	4.5%
Africa Fine Coffee Association	49	3.7%
Specialty Coffee Association of Costa Rica	42	3.2%
NUCOFFEE	36	2.7%
Other values (17)	166	12.7%

Length

Max length	88
Median length	28
Mean length	23.2804878
Min length	3

Harvest.Year
Categorical

HIGH CORRELATION
MISSING

Distinct count	47
Unique (%)	3.7%
Missing	49
Missing (%)	3.7%
Memory size	10.2 KiB

2012	351
2014	226
2013	170
2015	125
2016	122
Other values (42)	269

Common Values
Length

Value	Count	Frequency (%)
2012	351	26.8%
2014	226	17.2%
2013	170	13.0%
2015	125	9.5%
2016	122	9.3%
2017	68	5.2%
2013/2014	28	2.1%
2015/2016	28	2.1%
2011	26	2.0%
2017 / 2018	19	1.4%
Other values (37)	100	7.6%
(Missing)	49	3.7%

Length

Max length	24
Median length	4
Mean length	4.669969512
Min length	3

Grading.Date
Categorical

HIGH CARDINALITY

Distinct count	556
Unique (%)	42.4%
Missing	2
Missing (%)	0.2%
Memory size	10.2 KiB

July 11th, 2012	25
December 26th, 2013	24
June 6th, 2012	19
August 30th, 2012	18
July 26th, 2012	15
Other values (551)	1209

Common Values
Length

Value	Count	Frequency (%)
July 11th, 2012	25	1.9%
December 26th, 2013	24	1.8%
June 6th, 2012	19	1.4%
August 30th, 2012	18	1.4%
July 26th, 2012	15	1.1%
September 27th, 2012	13	1.0%
October 8th, 2015	13	1.0%
March 29th, 2013	13	1.0%
June 17th, 2010	12	0.9%
September 17th, 2012	11	0.8%
Other values (546)	1147	87.4%

Length

Max length	20
Median length	16
Mean length	16.56783537
Min length	3

Owner.1
Categorical

HIGH CARDINALITY

Distinct count	308
Unique (%)	23.7%
Missing	10
Missing (%)	0.8%
Memory size	10.2 KiB

Juan Luis Alvarado Romero	154
Racafe & Cia S.C.A	60
Exportadora de Cafe Condor S.A	54
Kona Pacific Farmers Cooperative	52
Ipanema Coffees	50
Other values (303)	932

Common Values
Length

Value	Count	Frequency (%)
Juan Luis Alvarado Romero	154	11.7%
Racafe & Cia S.C.A	60	4.6%
Exportadora de Cafe Condor S.A	54	4.1%
Kona Pacific Farmers Cooperative	52	4.0%
Ipanema Coffees	50	3.8%
CQI Taiwan ICP CQI??????	46	3.5%
Lin, Che-Hao Krude ???	30	2.3%
NUCOFFEE	29	2.2%
CARCAFE LTDA CI	27	2.1%
The Coffee Source Inc.	23	1.8%
Other values (298)	777	59.2%

Length

Max length	50
Median length	22
Mean length	21.22408537
Min length	1

Variety
Categorical

HIGH CORRELATION
MISSING

Distinct count	30
Unique (%)	2.7%
Missing	205
Missing (%)	15.6%
Memory size	10.2 KiB

Caturra	256
Bourbon	225
Typica	209
Other	108
Catuai	73
Other values (25)	236

Common Values
Length

Value	Count	Frequency (%)
Caturra	256	19.5%
Bourbon	225	17.1%
Typica	209	15.9%
Other	108	8.2%
Catuai	73	5.6%
Hawaiian Kona	44	3.4%
Yellow Bourbon	35	2.7%
Mundo Novo	33	2.5%
Catimor	20	1.5%
SL14	17	1.3%
Other values (20)	87	6.6%
(Missing)	205	15.6%

Length

Max length	21
Median length	6
Mean length	6.393292683
Min length	3

Processing.Method
Categorical

HIGH CORRELATION
MISSING

Distinct count	6
Unique (%)	0.5%
Missing	156
Missing (%)	11.9%
Memory size	10.2 KiB

Washed / Wet	809
Natural / Dry	250
Semi-washed / Semi-pulped	56
Other	26
Pulped natural / honey	14

Common Values
Length

Value	Count	Frequency (%)
Washed / Wet	809	61.7%
Natural / Dry	250	19.1%
Semi-washed / Semi-pulped	56	4.3%
Other	26	2.0%
Pulped natural / honey	14	1.1%
8	1	0.1%
(Missing)	156	11.9%

Length

Max length	25
Median length	12
Mean length	11.63490854
Min length	1

Aroma
Real number (ℝ_≥0)

Distinct count	34
Unique (%)	2.6%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	7.566689602446483
Minimum	0.0
Maximum	10.0
Zeros	1
Zeros (%)	0.1%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	7.08
Q1	7.42
median	7.58
Q3	7.75
95-th percentile	8.08
Maximum	10
Range	10
Interquartile range (IQR)	0.33

Descriptive statistics

Standard deviation	0.3842511432
Coefficient of variation (CV)	0.05078193548
Kurtosis	116.92108
Mean	7.566689602
Median Absolute Deviation (MAD)	0.17
Skewness	-5.868718879
Sum	9897.23
Variance	0.1476489411

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7.67	173	13.2%
7.5	162	12.3%
7.58	149	11.4%
7.75	122	9.3%
7.42	120	9.1%
7.83	101	7.7%
7.33	96	7.3%
7.25	77	5.9%
7.92	57	4.3%
7.17	45	3.4%
Other values (24)	206	15.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
5.08	1	0.1%
6.17	1	0.1%
6.33	1	0.1%
6.42	1	0.1%

Value	Count	Frequency (%)
10	1	0.1%
8.75	1	0.1%
8.67	2	0.2%
8.58	1	0.1%
8.5	3	0.2%

Flavor
Real number (ℝ_≥0)

Distinct count	36
Unique (%)	2.8%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	7.520917431192659
Minimum	0.0
Maximum	10.0
Zeros	1
Zeros (%)	0.1%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	6.948
Q1	7.33
median	7.58
Q3	7.75
95-th percentile	8
Maximum	10
Range	10
Interquartile range (IQR)	0.42

Descriptive statistics

Standard deviation	0.4054876999
Coefficient of variation (CV)	0.05391465916
Kurtosis	91.36064171
Mean	7.520917431
Median Absolute Deviation (MAD)	0.17
Skewness	-4.863105413
Sum	9837.36
Variance	0.1644202747

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7.5	164	12.5%
7.58	161	12.3%
7.67	145	11.1%
7.75	120	9.1%
7.42	114	8.7%
7.33	109	8.3%
7.83	85	6.5%
7.25	63	4.8%
7.17	56	4.3%
7.08	42	3.2%
Other values (26)	249	19.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
6.08	1	0.1%
6.17	2	0.2%
6.33	3	0.2%
6.42	1	0.1%

Value	Count	Frequency (%)
10	1	0.1%
8.83	1	0.1%
8.67	4	0.3%
8.58	2	0.2%
8.5	5	0.4%

Aftertaste
Real number (ℝ_≥0)

Distinct count	35
Unique (%)	2.7%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	7.397775229357799
Minimum	0.0
Maximum	8.67
Zeros	1
Zeros (%)	0.1%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	6.83
Q1	7.25
median	7.42
Q3	7.58
95-th percentile	7.92
Maximum	8.67
Range	8.67
Interquartile range (IQR)	0.33

Descriptive statistics

Standard deviation	0.4049340165
Coefficient of variation (CV)	0.05473726951
Kurtosis	84.97209599
Mean	7.397775229
Median Absolute Deviation (MAD)	0.17
Skewness	-4.852962343
Sum	9676.29
Variance	0.1639715577

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7.5	161	12.3%
7.33	150	11.4%
7.42	127	9.7%
7.58	125	9.5%
7.25	103	7.9%
7.67	98	7.5%
7.17	89	6.8%
7.75	81	6.2%
7	62	4.7%
7.83	61	4.6%
Other values (25)	251	19.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
6.17	7	0.5%
6.25	1	0.1%
6.33	6	0.5%
6.42	5	0.4%

Value	Count	Frequency (%)
8.67	1	0.1%
8.58	2	0.2%
8.5	4	0.3%
8.42	3	0.2%
8.33	2	0.2%

Acidity
Real number (ℝ_≥0)

SKEWED

Distinct count	32
Unique (%)	2.4%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	7.585175840978593
Minimum	0.0
Maximum	74.75
Zeros	1
Zeros (%)	0.1%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	7.33
median	7.5
Q3	7.75
95-th percentile	8.08
Maximum	74.75
Range	74.75
Interquartile range (IQR)	0.42

Descriptive statistics

Standard deviation	1.897340235
Coefficient of variation (CV)	0.2501379368
Kurtosis	1204.18733
Mean	7.585175841
Median Absolute Deviation (MAD)	0.17
Skewness	33.94016411
Sum	9921.41
Variance	3.599899969

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7.5	159	12.1%
7.58	150	11.4%
7.67	143	10.9%
7.42	127	9.7%
7.75	122	9.3%
7.33	109	8.3%
7.25	85	6.5%
7.17	72	5.5%
7.83	72	5.5%
8	47	3.6%
Other values (22)	222	16.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
5.25	1	0.1%
6.08	1	0.1%
6.25	1	0.1%
6.5	1	0.1%

Value	Count	Frequency (%)
74.75	1	0.1%
8.75	1	0.1%
8.58	1	0.1%
8.5	7	0.5%
8.42	6	0.5%

Body
Real number (ℝ_≥0)

Distinct count	32
Unique (%)	2.4%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	7.5125611620795105
Minimum	0.0
Maximum	8.58
Zeros	1
Zeros (%)	0.1%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	7.08
Q1	7.33
median	7.5
Q3	7.67
95-th percentile	8
Maximum	8.58
Range	8.58
Interquartile range (IQR)	0.34

Descriptive statistics

Standard deviation	0.4134971499
Coefficient of variation (CV)	0.05504076985
Kurtosis	161.2857803
Mean	7.512561162
Median Absolute Deviation (MAD)	0.17
Skewness	-9.06857238
Sum	9826.43
Variance	0.170979893

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7.5	198	15.1%
7.67	149	11.4%
7.58	136	10.4%
7.33	131	10.0%
7.42	124	9.5%
7.75	107	8.2%
7.25	85	6.5%
7.83	82	6.2%
7.17	68	5.2%
7.92	48	3.7%
Other values (22)	180	13.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
0.11	1	0.1%
5.25	1	0.1%
6.33	2	0.2%
6.42	1	0.1%

Value	Count	Frequency (%)
8.58	1	0.1%
8.5	3	0.2%
8.42	3	0.2%
8.33	6	0.5%
8.25	5	0.4%

Balance
Real number (ℝ_≥0)

Distinct count	32
Unique (%)	2.4%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	7.512454128440368
Minimum	0.0
Maximum	8.75
Zeros	2
Zeros (%)	0.2%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	6.92
Q1	7.33
median	7.5
Q3	7.75
95-th percentile	8.08
Maximum	8.75
Range	8.75
Interquartile range (IQR)	0.42

Descriptive statistics

Standard deviation	0.4559413295
Coefficient of variation (CV)	0.06069139615
Kurtosis	111.7153503
Mean	7.512454128
Median Absolute Deviation (MAD)	0.17
Skewness	-6.831097072
Sum	9826.29
Variance	0.207882496

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7.5	171	13.0%
7.67	145	11.1%
7.58	127	9.7%
7.42	120	9.1%
7.75	103	7.9%
7.33	99	7.5%
7.83	97	7.4%
7.17	71	5.4%
7.25	63	4.8%
7	46	3.5%
Other values (22)	266	20.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.2%
6.08	1	0.1%
6.17	3	0.2%
6.33	1	0.1%
6.42	1	0.1%

Value	Count	Frequency (%)
8.75	2	0.2%
8.58	7	0.5%
8.5	7	0.5%
8.42	7	0.5%
8.33	7	0.5%

Uniformity
Real number (ℝ_≥0)

Distinct count	10
Unique (%)	0.8%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	9.827408256880734
Minimum	0.0
Maximum	10.0
Zeros	2
Zeros (%)	0.2%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	8.67
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6202594134
Coefficient of variation (CV)	0.06311525859
Kurtosis	102.9496688
Mean	9.827408257
Median Absolute Deviation (MAD)	0
Skewness	-8.095186971
Sum	12854.25
Variance	0.3847217399

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	1126	85.8%
9.33	111	8.5%
8.67	31	2.4%
8	24	1.8%
6.67	7	0.5%
6	3	0.2%
7.33	2	0.2%
0	2	0.2%
9	1	0.1%
9.5	1	0.1%
(Missing)	4	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.2%
6	3	0.2%
6.67	7	0.5%
7.33	2	0.2%
8	24	1.8%

Value	Count	Frequency (%)
10	1126	85.8%
9.5	1	0.1%
9.33	111	8.5%
9	1	0.1%
8.67	31	2.4%

Clean.Cup
Real number (ℝ_≥0)

Distinct count	11
Unique (%)	0.8%
Missing	5
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%

Mean	9.833121652639631
Minimum	0.0
Maximum	10.0
Zeros	2
Zeros (%)	0.2%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	9.33
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7723632038
Coefficient of variation (CV)	0.07854710143
Kurtosis	69.01590398
Mean	9.833121653
Median Absolute Deviation (MAD)	0
Skewness	-7.371180435
Sum	12851.89
Variance	0.5965449186

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	1191	90.8%
9.33	57	4.3%
8.67	16	1.2%
6.67	13	1.0%
8	13	1.0%
6	6	0.5%
7.33	3	0.2%
5.33	3	0.2%
2.67	2	0.2%
0	2	0.2%
(Missing)	5	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.2%
1.33	1	0.1%
2.67	2	0.2%
5.33	3	0.2%
6	6	0.5%

Value	Count	Frequency (%)
10	1191	90.8%
9.33	57	4.3%
8.67	16	1.2%
8	13	1.0%
7.33	3	0.2%

Sweetness
Real number (ℝ_≥0)

Distinct count	8
Unique (%)	0.6%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	9.9040749235474
Minimum	0.0
Maximum	10.0
Zeros	1
Zeros (%)	0.1%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	9.33
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5309599084
Coefficient of variation (CV)	0.05361024755
Kurtosis	157.8063887
Mean	9.904074924
Median Absolute Deviation (MAD)	0
Skewness	-10.77587083
Sum	12954.53
Variance	0.2819184244

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	1217	92.8%
9.33	59	4.5%
8.67	12	0.9%
8	8	0.6%
6.67	7	0.5%
6	3	0.2%
1.33	1	0.1%
0	1	0.1%
(Missing)	4	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1.33	1	0.1%
6	3	0.2%
6.67	7	0.5%
8	8	0.6%

Value	Count	Frequency (%)
10	1217	92.8%
9.33	59	4.5%
8.67	12	0.9%
8	8	0.6%
6.67	7	0.5%

Cupper.Points
Categorical

HIGH CORRELATION

Distinct count	43
Unique (%)	3.3%
Missing	4
Missing (%)	0.3%
Memory size	10.2 KiB

7.5	151
7.58	135
7.33	114
7.67	113
7.42	103
Other values (38)	692

Common Values
Length

Value	Count	Frequency (%)
7.5	151	11.5%
7.58	135	10.3%
7.33	114	8.7%
7.67	113	8.6%
7.42	103	7.9%
7.25	85	6.5%
7.75	84	6.4%
7.83	81	6.2%
7.17	63	4.8%
7.92	52	4.0%
Other values (33)	327	24.9%

Length

Max length	17
Median length	4
Mean length	3.639481707
Min length	1

Total.Cup.Points
Categorical

HIGH CARDINALITY

Distinct count	179
Unique (%)	13.7%
Missing	4
Missing (%)	0.3%
Memory size	10.2 KiB

83.17	38
83	37
82.42	31
82.33	29
82.75	29
Other values (174)	1144

Common Values
Length

Value	Count	Frequency (%)
83.17	38	2.9%
83	37	2.8%
82.42	31	2.4%
82.33	29	2.2%
82.75	29	2.2%
82.67	26	2.0%
81.83	26	2.0%
82.92	26	2.0%
81.67	25	1.9%
83.25	24	1.8%
Other values (169)	1017	77.5%

Length

Max length	29
Median length	5
Mean length	4.616615854
Min length	1

Moisture
Categorical

HIGH CORRELATION

Distinct count	24
Unique (%)	1.8%
Missing	4
Missing (%)	0.3%
Memory size	10.2 KiB

0.11	377
0.12	284
0	252
0.1	180
0.13	75
Other values (19)	140

Common Values
Length

Value	Count	Frequency (%)
0.11	377	28.7%
0.12	284	21.6%
0	252	19.2%
0.1	180	13.7%
0.13	75	5.7%
0.09	26	2.0%
0.14	23	1.8%
0.08	16	1.2%
0.01	15	1.1%
0.15	8	0.6%
Other values (14)	52	4.0%

Length

Max length	40
Median length	4
Mean length	3.308689024
Min length	1

Category.One.Defects
Categorical

HIGH CORRELATION

Distinct count	17
Unique (%)	1.3%
Missing	4
Missing (%)	0.3%
Memory size	10.2 KiB

0	1107
1	101
2	38
3	18
4	16
Other values (12)	28

Common Values
Length

Value	Count	Frequency (%)
0	1107	84.4%
1	101	7.7%
2	38	2.9%
3	18	1.4%
4	16	1.2%
5	9	0.7%
10	4	0.3%
6	3	0.2%
7	3	0.2%
31	2	0.2%
Other values (7)	7	0.5%
(Missing)	4	0.3%

Length

Max length	40
Median length	1
Mean length	1.043445122
Min length	1

Quakers
Categorical

HIGH CORRELATION

Distinct count	12
Unique (%)	0.9%
Missing	5
Missing (%)	0.4%
Memory size	10.2 KiB

0	1212
1	39
2	30
3	5
4	5
Other values (7)	16

Common Values
Length

Value	Count	Frequency (%)
0	1212	92.4%
1	39	3.0%
2	30	2.3%
3	5	0.4%
4	5	0.4%
5	5	0.4%
6	4	0.3%
7	3	0.2%
11	1	0.1%
9	1	0.1%
Other values (2)	2	0.2%
(Missing)	5	0.4%

Length

Max length	3
Median length	1
Mean length	1.008384146
Min length	1

Color
Categorical

MISSING

Distinct count	4
Unique (%)	0.4%
Missing	220
Missing (%)	16.8%
Memory size	10.2 KiB

Green	848
Bluish-Green	112
Blue-Green	81
None	51

Common Values
Length

Value	Count	Frequency (%)
Green	848	64.6%
Bluish-Green	112	8.5%
Blue-Green	81	6.2%
None	51	3.9%
(Missing)	220	16.8%

Length

Max length	12
Median length	5
Mean length	5.532012195
Min length	3

Category.Two.Defects
Real number (ℝ_≥0)

ZEROS

Distinct count	38
Unique (%)	2.9%
Missing	5
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%

Mean	3.595256312165264
Minimum	0.0
Maximum	55.0
Zeros	359
Zeros (%)	27.4%
Memory size	10.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	4
95-th percentile	13
Maximum	55
Range	55
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	5.3528549
Coefficient of variation (CV)	1.488866004
Kurtosis	19.83427897
Mean	3.595256312
Median Absolute Deviation (MAD)	2
Skewness	3.652168336
Sum	4699
Variance	28.65305558

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	359	27.4%
1	200	15.2%
2	178	13.6%
3	133	10.1%
4	118	9.0%
5	73	5.6%
6	42	3.2%
7	39	3.0%
8	29	2.2%
9	22	1.7%
Other values (28)	114	8.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	359	27.4%
1	200	15.2%
2	178	13.6%
3	133	10.1%
4	118	9.0%

Value	Count	Frequency (%)
55	1	0.1%
47	1	0.1%
45	1	0.1%
40	1	0.1%
38	1	0.1%

Expiration
Categorical

HIGH CARDINALITY

Distinct count	554
Unique (%)	42.4%
Missing	5
Missing (%)	0.4%
Memory size	10.2 KiB

July 11th, 2013	25
December 26th, 2014	24
June 6th, 2013	19
August 30th, 2013	18
July 26th, 2013	15
Other values (549)	1206

Common Values
Length

Value	Count	Frequency (%)
July 11th, 2013	25	1.9%
December 26th, 2014	24	1.8%
June 6th, 2013	19	1.4%
August 30th, 2013	18	1.4%
July 26th, 2013	15	1.1%
October 7th, 2016	13	1.0%
March 29th, 2014	13	1.0%
September 27th, 2013	13	1.0%
June 17th, 2011	12	0.9%
October 20th, 2018	11	0.8%
Other values (544)	1144	87.2%

Length

Max length	20
Median length	16
Mean length	16.5464939
Min length	3

Certification.Body
Categorical

HIGH CORRELATION

Distinct count	25
Unique (%)	1.9%
Missing	5
Missing (%)	0.4%
Memory size	10.2 KiB

Specialty Coffee Association	293
AMECAFE	205
AlmacafÃ©	178
Asociacion Nacional Del CafÃ©	154
Brazil Specialty Coffee Association	67
Other values (20)	410

Common Values
Length

Value	Count	Frequency (%)
Specialty Coffee Association	293	22.3%
AMECAFE	205	15.6%
AlmacafÃ©	178	13.6%
Asociacion Nacional Del CafÃ©	154	11.7%
Brazil Specialty Coffee Association	67	5.1%
Instituto HondureÃ±o del CafÃ©	60	4.6%
Blossom Valley International	58	4.4%
Africa Fine Coffee Association	49	3.7%
Specialty Coffee Association of Costa Rica	43	3.3%
NUCOFFEE	36	2.7%
Other values (15)	164	12.5%

Length

Max length	88
Median length	28
Mean length	23.23932927
Min length	3

Certification.Address
Categorical

HIGH CORRELATION

Distinct count	28
Unique (%)	2.1%
Missing	5
Missing (%)	0.4%
Memory size	10.2 KiB

36d0d00a3724338ba7937c52a378d085f2172daa	293
59e396ad6e22a1c22b248f958e1da2bd8af85272	204
e493c36c2d076bf273064f7ac23ad562af257a25	178
b1f20fe3a819fd6b2ee0eb8fdc3da256604f1e53	154
3297cfa4c538e3dd03f72cc4082c54f7999e1f9d	67
Other values (23)	411

Common Values
Length

Value	Count	Frequency (%)
36d0d00a3724338ba7937c52a378d085f2172daa	293	22.3%
59e396ad6e22a1c22b248f958e1da2bd8af85272	204	15.5%
e493c36c2d076bf273064f7ac23ad562af257a25	178	13.6%
b1f20fe3a819fd6b2ee0eb8fdc3da256604f1e53	154	11.7%
3297cfa4c538e3dd03f72cc4082c54f7999e1f9d	67	5.1%
b4660a57e9f8cc613ae5b8f02bfce8634c763ab4	60	4.6%
fc45352eee499d8470cf94c9827922fb745bf815	58	4.4%
073285c0d45e2f5539012d969937e529564fa6fe	48	3.7%
8e0b118f3cf3121ab27c5387deacdb7d4d2a60b1	42	3.2%
567f200bcc17a90070cb952647bf88141ad9c80c	36	2.7%
Other values (18)	167	12.7%

Length

Max length	40
Median length	40
Mean length	39.8589939
Min length	3

Certification.Contact
Categorical

HIGH CORRELATION

Distinct count	26
Unique (%)	2.0%
Missing	5
Missing (%)	0.4%
Memory size	10.2 KiB

0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660	293
0eb4ee5b3f47b20b049548a2fd1e7d4a2b70d0a7	204
70d3c0c26f89e00fdae6fb39ff54f0d2eb1c38ab	178
724f04ad10ed31dbb9d260f0dfd221ba48be8a95	154
8900f0bf1d0b2bafe6807a73562c7677d57eb980	67
Other values (21)	411

Common Values
Length

Value	Count	Frequency (%)
0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660	293	22.3%
0eb4ee5b3f47b20b049548a2fd1e7d4a2b70d0a7	204	15.5%
70d3c0c26f89e00fdae6fb39ff54f0d2eb1c38ab	178	13.6%
724f04ad10ed31dbb9d260f0dfd221ba48be8a95	154	11.7%
8900f0bf1d0b2bafe6807a73562c7677d57eb980	67	5.1%
7f521ca403540f81ec99daec7da19c2788393880	60	4.6%
de73fc9412358b523d3a641501e542f31d2668b0	58	4.4%
c4ab13415cdd69376a93780c0166e7b1a10481ea	49	3.7%
5eb2b7129d9714c43825e44dc3bca9423de209e9	43	3.3%
aa2ff513ffb9c844462a1fb07c599bce7f3bb53d	36	2.7%
Other values (16)	165	12.6%

Length

Max length	40
Median length	40
Mean length	39.8589939
Min length	3

unit_of_measurement
Categorical

Distinct count	2
Unique (%)	0.2%
Missing	5
Missing (%)	0.4%
Memory size	10.2 KiB

m	1125
ft	182

Common Values
Length

Value	Count	Frequency (%)
m	1125	85.7%
ft	182	13.9%
(Missing)	5	0.4%

Length

Max length	3
Median length	1
Mean length	1.146341463
Min length	1

altitude_low_meters
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count	188
Unique (%)	17.4%
Missing	231
Missing (%)	17.6%
Infinite	0
Infinite (%)	0.0%

Mean	1762.0268884366326
Minimum	1.0
Maximum	190164.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.2 KiB

Quantile statistics

Minimum	1
5-th percentile	442
Q1	1100
median	1310.64
Q3	1600
95-th percentile	1850
Maximum	190164
Range	190163
Interquartile range (IQR)	500

Descriptive statistics

Standard deviation	8779.88323
Coefficient of variation (CV)	4.982831583
Kurtosis	413.3246208
Mean	1762.026888
Median Absolute Deviation (MAD)	239.36
Skewness	20.07018989
Sum	1904751.066
Variance	77086349.53

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1200	80	6.1%
1600	65	5.0%
1400	59	4.5%
1500	54	4.1%
1100	54	4.1%
1300	48	3.7%
1800	41	3.1%
1250	38	2.9%
1700	36	2.7%
1550	31	2.4%
Other values (178)	575	43.8%
(Missing)	231	17.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	14	1.1%
12	3	0.2%
13	2	0.2%
50	1	0.1%
100	2	0.2%

Value	Count	Frequency (%)
190164	2	0.2%
110000	1	0.1%
11000	1	0.1%
4287	1	0.1%
4001	1	0.1%

altitude_high_meters
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count	188
Unique (%)	17.4%
Missing	231
Missing (%)	17.6%
Infinite	0
Infinite (%)	0.0%

Mean	1811.4585406105462
Minimum	1.0
Maximum	190164.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.2 KiB

Quantile statistics

Minimum	1
5-th percentile	442
Q1	1100
median	1350
Q3	1650
95-th percentile	1950
Maximum	190164
Range	190163
Interquartile range (IQR)	550

Descriptive statistics

Standard deviation	8779.208199
Coefficient of variation (CV)	4.846485858
Kurtosis	412.9991037
Mean	1811.458541
Median Absolute Deviation (MAD)	250
Skewness	20.05804142
Sum	1958186.682
Variance	77074496.61

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1200	65	5.0%
1400	63	4.8%
1100	53	4.0%
1500	51	3.9%
1300	44	3.4%
1800	44	3.4%
1700	42	3.2%
1250	39	3.0%
1600	34	2.6%
1950	33	2.5%
Other values (178)	613	46.7%
(Missing)	231	17.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12	0.9%
12	3	0.2%
13	2	0.2%
50	1	0.1%
100	1	0.1%

Value	Count	Frequency (%)
190164	2	0.2%
110000	1	0.1%
11000	1	0.1%
5900	1	0.1%
4287	1	0.1%

altitude_mean_meters
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct count	201
Unique (%)	18.6%
Missing	231
Missing (%)	17.6%
Infinite	0
Infinite (%)	0.0%

Mean	1786.7427145235893
Minimum	1.0
Maximum	190164.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.2 KiB

Quantile statistics

Minimum	1
5-th percentile	442
Q1	1100
median	1317
Q3	1600
95-th percentile	1880
Maximum	190164
Range	190163
Interquartile range (IQR)	500

Descriptive statistics

Standard deviation	8779.044646
Coefficient of variation (CV)	4.913435256
Kurtosis	413.2568432
Mean	1786.742715
Median Absolute Deviation (MAD)	233
Skewness	20.06752535
Sum	1931468.874
Variance	77071624.9

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1200	66	5.0%
1400	52	4.0%
1100	51	3.9%
1300	50	3.8%
1500	44	3.4%
1250	39	3.0%
1700	36	2.7%
1600	35	2.7%
1750	34	2.6%
1550	34	2.6%
Other values (191)	640	48.8%
(Missing)	231	17.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12	0.9%
12	3	0.2%
13	2	0.2%
50	1	0.1%
100	1	0.1%

Value	Count	Frequency (%)
190164	2	0.2%
110000	1	0.1%
11000	1	0.1%
4287	1	0.1%
4001	1	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	df_index	ID	Species	Owner	Country.of.Origin	Farm.Name	Mill	ICO.Number	Company	Altitude	Region	Producer	Number.of.Bags	Bag.Weight	In.Country.Partner	Harvest.Year	Grading.Date	Owner.1	Variety	Processing.Method	Aroma	Flavor	Aftertaste	Acidity	Body	Balance	Uniformity	Clean.Cup	Sweetness	Cupper.Points	Total.Cup.Points	Moisture	Color	Category.Two.Defects	Expiration	Certification.Body	Certification.Address	Certification.Contact	unit_of_measurement	altitude_low_meters	altitude_high_meters	altitude_mean_meters
0	0	1	Arabica	metad plc	Ethiopia	metad plc	metad plc	2014/2015	metad agricultural developmet plc	1950-2200	guji-hambela	METAD PLC	300	60 kg	METAD Agricultural Development plc	2014	April 4th, 2015	metad plc	NaN	Washed / Wet	8.67	8.83	8.67	8.75	8.50	8.42	10.00	10.0	10.00	8.75	90.58	0.12	Green	0.0	April 3rd, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1950.0	2200.0	2075.0
1	1	2	Arabica	metad plc	Ethiopia	metad plc	metad plc	2014/2015	metad agricultural developmet plc	1950-2200	guji-hambela	METAD PLC	300	60 kg	METAD Agricultural Development plc	2014	April 4th, 2015	metad plc	Other	Washed / Wet	8.75	8.67	8.50	8.58	8.42	8.42	10.00	10.0	10.00	8.58	89.92	0.12	Green	1.0	April 3rd, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1950.0	2200.0	2075.0
2	2	3	Arabica	grounds for health admin	Guatemala	san marcos barrancas "san cristobal cuch	NaN	NaN	NaN	1600 - 1800 m	NaN	NaN	5	1	Specialty Coffee Association	NaN	May 31st, 2010	Grounds for Health Admin	Bourbon	NaN	8.42	8.50	8.42	8.42	8.33	8.42	10.00	10.0	10.00	9.25	89.75	0	NaN	0.0	May 31st, 2011	Specialty Coffee Association	36d0d00a3724338ba7937c52a378d085f2172daa	0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660	m	1600.0	1800.0	1700.0
3	3	4	Arabica	yidnekachew dabessa	Ethiopia	yidnekachew dabessa coffee plantation	wolensu	NaN	yidnekachew debessa coffee plantation	1800-2200	oromia	Yidnekachew Dabessa Coffee Plantation	320	60 kg	METAD Agricultural Development plc	2014	March 26th, 2015	Yidnekachew Dabessa	NaN	Natural / Dry	8.17	8.58	8.42	8.42	8.50	8.25	10.00	10.0	10.00	8.67	89	0.11	Green	2.0	March 25th, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1800.0	2200.0	2000.0
4	4	5	Arabica	metad plc	Ethiopia	metad plc	metad plc	2014/2015	metad agricultural developmet plc	1950-2200	guji-hambela	METAD PLC	300	60 kg	METAD Agricultural Development plc	2014	April 4th, 2015	metad plc	Other	Washed / Wet	8.25	8.50	8.25	8.50	8.42	8.33	10.00	10.0	10.00	8.58	88.83	0.12	Green	2.0	April 3rd, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1950.0	2200.0	2075.0
5	5	6	Arabica	ji-ae ahn	Brazil	NaN	NaN	NaN	NaN	NaN	NaN	NaN	100	30 kg	Specialty Coffee Institute of Asia	2013	September 3rd, 2013	Ji-Ae Ahn	NaN	Natural / Dry	8.58	8.42	8.42	8.50	8.25	8.33	10.00	10.0	10.00	8.33	88.83	0.11	Bluish-Green	1.0	September 3rd, 2014	Specialty Coffee Institute of Asia	726e4891cf2c9a4848768bd34b668124d12c4224	b70da261fcc84831e3e9620c30a8701540abc200	m	NaN	NaN	NaN
6	6	7	Arabica	hugo valdivia	Peru	NaN	hvc	NaN	richmond investment-coffee department	NaN	NaN	HVC	100	69 kg	Specialty Coffee Institute of Asia	2012	September 17th, 2012	Hugo Valdivia	Other	Washed / Wet	8.42	8.50	8.33	8.50	8.25	8.25	10.00	10.0	10.00	8.5	88.75	0.11	Bluish-Green	0.0	September 17th, 2013	Specialty Coffee Institute of Asia	726e4891cf2c9a4848768bd34b668124d12c4224	b70da261fcc84831e3e9620c30a8701540abc200	m	NaN	NaN	NaN
7	7	8	Arabica	ethiopia commodity exchange	Ethiopia	aolme	c.p.w.e	010/0338	NaN	1570-1700	oromia	Bazen Agricultural & Industrial Dev't Plc	300	60 kg	Ethiopia Commodity Exchange	March 2010	September 2nd, 2010	Ethiopia Commodity Exchange	NaN	NaN	8.25	8.33	8.50	8.42	8.33	8.50	10.00	10.0	9.33	9	88.67	0.03	NaN	0.0	September 2nd, 2011	Ethiopia Commodity Exchange	a176532400aebdc345cf3d870f84ed3ecab6249e	61bbaf6a9f341e5782b8e7bd3ebf76aac89fe24b	m	1570.0	1700.0	1635.0
8	8	9	Arabica	ethiopia commodity exchange	Ethiopia	aolme	c.p.w.e	010/0338	NaN	1570-1700	oromiya	Bazen Agricultural & Industrial Dev't Plc	300	60 kg	Ethiopia Commodity Exchange	March 2010	September 2nd, 2010	Ethiopia Commodity Exchange	NaN	NaN	8.67	8.67	8.58	8.42	8.33	8.42	9.33	10.0	9.33	8.67	88.42	0.03	NaN	0.0	September 2nd, 2011	Ethiopia Commodity Exchange	a176532400aebdc345cf3d870f84ed3ecab6249e	61bbaf6a9f341e5782b8e7bd3ebf76aac89fe24b	m	1570.0	1700.0	1635.0
9	9	10	Arabica	diamond enterprise plc	Ethiopia	tulla coffee farm	tulla coffee farm	2014/15	diamond enterprise plc	1795-1850	snnp/kaffa zone,gimbowereda	Diamond Enterprise Plc	50	60 kg	METAD Agricultural Development plc	2014	March 30th, 2015	Diamond Enterprise Plc	Other	Natural / Dry	8.08	8.58	8.50	8.50	7.67	8.42	10.00	10.0	10.00	8.5	88.25	0.1	Green	4.0	March 29th, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1795.0	1850.0	1822.5

Last rows

	df_index	ID	Species	Owner	Country.of.Origin	Farm.Name	Mill	ICO.Number	Company	Altitude	Region	Producer	Number.of.Bags	Bag.Weight	In.Country.Partner	Harvest.Year	Grading.Date	Owner.1	Variety	Processing.Method	Aroma	Flavor	Aftertaste	Acidity	Body	Balance	Uniformity	Clean.Cup	Sweetness	Cupper.Points	Total.Cup.Points	Moisture	Category.One.Defects	Quakers	Color	Category.Two.Defects	Expiration	Certification.Body	Certification.Address	Certification.Contact	unit_of_measurement	altitude_low_meters	altitude_high_meters	altitude_mean_meters
1302	1309	1302	Arabica	kurt kappeli	Mexico	various	f.i.e.c.h.	0016-2847-0001	globus coffee	1000 meters	sierra norte yajalon, chiapas	various small producers	280	2 kg	Specialty Coffee Association	2014	May 5th, 2014	Kurt Kappeli	Typica	Washed / Wet	6.92	7.00	6.83	6.92	7.42	6.92	6.00	6.00	10.00	6.75	70.75	0.12	0	0	Green	1.0	May 5th, 2015	Specialty Coffee Association	36d0d00a3724338ba7937c52a378d085f2172daa	0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660	m	1000.00	1000.00	1000.00
1303	1310	1303	Arabica	volcafe ltda. - brasil	Brazil	NaN	copag	NaN	volcafe ltda.	NaN	cerrado	NaN	305	59 kg	Brazil Specialty Coffee Association	2017 / 2018	October 27th, 2017	Volcafe Ltda. - Brasil	NaN	Natural / Dry	7.00	7.00	6.83	7.00	7.33	6.83	6.00	6.00	10.00	6.67	70.67	0.11	0	1	Green	55.0	October 27th, 2018	Brazil Specialty Coffee Association	3297cfa4c538e3dd03f72cc4082c54f7999e1f9d	8900f0bf1d0b2bafe6807a73562c7677d57eb980	m	NaN	NaN	NaN
1304	1311	1304	Arabica	cadexsa	Honduras	cerro bueno	cadexsa	13-63-174	cadexsa	1450 msnm	marcala	Omar Acosta	275	1 kg	Instituto HondureÃ±o del CafÃ©	2014	May 15th, 2014	CADEXSA	Catuai	Washed / Wet	6.67	6.50	6.17	6.67	6.83	6.17	8.00	8.00	8.00	6.33	69.33	0.1	0	0	Green	4.0	May 15th, 2015	Instituto HondureÃ±o del CafÃ©	b4660a57e9f8cc613ae5b8f02bfce8634c763ab4	7f521ca403540f81ec99daec7da19c2788393880	m	1450.00	1450.00	1450.00
1305	1312	1305	Arabica	cadexsa	Honduras	cerro bueno	cadexsa	13-63-174	cadexsa	1450 msnm	marcala	Omar Acosta	275	1 kg	Instituto HondureÃ±o del CafÃ©	2014	May 15th, 2014	CADEXSA	Catuai	Washed / Wet	7.00	6.17	6.17	6.67	6.50	6.17	8.00	8.00	8.00	6.5	69.17	0.1	0	0	Green	3.0	May 15th, 2015	Instituto HondureÃ±o del CafÃ©	b4660a57e9f8cc613ae5b8f02bfce8634c763ab4	7f521ca403540f81ec99daec7da19c2788393880	m	1450.00	1450.00	1450.00
1306	1313	1306	Arabica	cadexsa	Honduras	cerro bueno	cadexsa	13-63-174	cadexsa	1450 msnm	marcala	Omar Acosta	275	1 kg	Instituto HondureÃ±o del CafÃ©	2014	May 15th, 2014	CADEXSA	Catuai	Washed / Wet	7.00	6.33	6.17	6.50	6.67	6.17	8.00	8.00	8.00	6.33	69.17	0.1	0	0	Green	4.0	May 15th, 2015	Instituto HondureÃ±o del CafÃ©	b4660a57e9f8cc613ae5b8f02bfce8634c763ab4	7f521ca403540f81ec99daec7da19c2788393880	m	1450.00	1450.00	1450.00
1307	1314	1307	Arabica	juan carlos garcia lopez	Mexico	el centenario	la esperanza, municipio juchique de ferrer, veracruz	1104328663	terra mia	900	juchique de ferrer	JUAN CARLOS GARCÃA LOPEZ	12	1 kg	AMECAFE	2012	September 17th, 2012	JUAN CARLOS GARCIA LOPEZ	Bourbon	Washed / Wet	7.08	6.83	6.25	7.42	7.25	6.75	10.00	0.00	10.00	6.75	68.33	0.11	0	0	None	20.0	September 17th, 2013	AMECAFE	59e396ad6e22a1c22b248f958e1da2bd8af85272	0eb4ee5b3f47b20b049548a2fd1e7d4a2b70d0a7	m	900.00	900.00	900.00
1308	1315	1308	Arabica	myriam kaplan-pasternak	Haiti	200 farms	coeb koperativ ekselsyo basen (350 members)	NaN	haiti coffee	~350m	department d'artibonite , haiti	COEB Koperativ Ekselsyo Basen	1	2 kg	Specialty Coffee Association	2012	May 24th, 2012	Myriam Kaplan-Pasternak	Typica	Natural / Dry	6.75	6.58	6.42	6.67	7.08	6.67	9.33	6.00	6.00	6.42	67.92	0.14	8	0	Blue-Green	16.0	May 24th, 2013	Specialty Coffee Association	36d0d00a3724338ba7937c52a378d085f2172daa	0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660	m	350.00	350.00	350.00
1309	1316	1309	Arabica	exportadora atlantic, s.a.	Nicaragua	finca las marÃas	beneficio atlantic condega	017-053-0211/ 017-053-0212	exportadora atlantic s.a	1100	jalapa	TeÃ³filo NarvÃ¡ez	550	69 kg	Instituto HondureÃ±o del CafÃ©	2016	June 6th, 2017	Exportadora Atlantic, S.A.	Caturra	Other	7.25	6.58	6.33	6.25	6.42	6.08	6.00	6.00	6.00	6.17	63.08	0.13	1	0	Green	5.0	June 6th, 2018	Instituto HondureÃ±o del CafÃ©	b4660a57e9f8cc613ae5b8f02bfce8634c763ab4	7f521ca403540f81ec99daec7da19c2788393880	m	1100.00	1100.00	1100.00
1310	1317	1310	Arabica	juan luis alvarado romero	Guatemala	finca el limon	beneficio serben	11/853/165	unicafe	4650	nuevo oriente	WILLIAM ESTUARDO MARTINEZ PACHECO	275	1 kg	Asociacion Nacional Del CafÃ©	2012	May 24th, 2012	Juan Luis Alvarado Romero	Catuai	Washed / Wet	7.50	6.67	6.67	7.67	7.33	6.67	8.00	1.33	1.33	6.67	59.83	0.1	0	0	Green	4.0	May 24th, 2013	Asociacion Nacional Del CafÃ©	b1f20fe3a819fd6b2ee0eb8fdc3da256604f1e53	724f04ad10ed31dbb9d260f0dfd221ba48be8a95	ft	1417.32	1417.32	1417.32
1311	1318	1312	Arabica	bismarck castro	Honduras	los hicaques	cigrah s.a de c.v.	13-111-053	cigrah s.a de c.v	1400	comayagua	Reinerio Zepeda	275	69 kg	Instituto HondureÃ±o del CafÃ©	2017	April 28th, 2017	Bismarck Castro	Caturra	NaN	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0	0	0.12	0	0	Green	2.0	April 28th, 2018	Instituto HondureÃ±o del CafÃ©	b4660a57e9f8cc613ae5b8f02bfce8634c763ab4	7f521ca403540f81ec99daec7da19c2788393880	m	1400.00	1400.00	1400.00

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows